##############################################################
## :   . / Speed Internet User
## : dimka3210
##		  TorrentPier II: TorrentPier.me
## :       
##
## C : 
##
## ,   : ~ 5 
##
##############################################################
##    ,       ,    
##############################################################

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE IF NOT EXISTS `bb_users_speed` (
  `speed_id` mediumint(3) NOT NULL AUTO_INCREMENT,
  `speed_str` varchar(30) NOT NULL,
  PRIMARY KEY (`speed_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
INSERT INTO `bb_users_speed` (`speed_id`, `speed_str`) VALUES
(1, '100 Kbps'),
(2, '200 Kbps'),
(3, '300 Kbps'),
(4, '400 Kbps'),
(5, '500 Kbps'),
(6, '600 Kbps'),
(7, '700 Kbps'),
(8, '800 Kbps'),
(9, '900 Kbps'),
(10, '1 Mbit'),
(11, '2 Mbit'),
(12, '3 Mbit'),
(13, '4 Mbit'),
(14, '5 Mbit'),
(15, '6 Mbit'),
(16, '7 Mbit'),
(17, '8 Mbit'),
(18, '9 Mbit'),
(19, '10 Mbit'),
(20, '20 Mbit'),
(21, '30 Mbit'),
(22, '40 Mbit'),
(23, '50 Mbit'),
(24, '60 Mbit'),
(25, '70 Mbit'),
(26, '80 Mbit'),
(27, '90 Mbit'),
(28, '100 Mbit'),
(29, '200 Mbit'),
(30, '300 Mbit'),
(31, '400 Mbit'),
(32, '500 Mbit'),
(33, '600 Mbit'),
(34, '700 Mbit'),
(35, '800 Mbit'),
(36, '900 Mbit'),
(37, '1 Gbit');
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `bb_users` ADD `user_speed_up` INT( 3 ) NOT NULL DEFAULT '0' AFTER `user_gender`;
ALTER TABLE `bb_users` ADD `user_speed_down` INT( 3 ) NOT NULL DEFAULT '0' AFTER `user_speed_up`;
#
#-----[   ]------------------------------------------
#

 root/images/speed_down.png to /images/speed_down.png
 root/images/speed_up.png to /images/speed_up.png

#
#-----[  ]------------------------------------------
#
templates/default/viewtopic.tpl
#
#-----[  ]------------------------------------------
# 
<!-- IF postrow.POSTER_AVATAR --><p class="avatar">{postrow.POSTER_AVATAR}</p><!-- ENDIF -->
#
#-----[   ]------------------------------------------
# 
<!-- IF postrow.USER_SPEED_DOWN --><p><em>{TS_DOWNLOADSPEED}</em> {postrow.USER_SPEED_DOWN}
		<em>{TS_UPLOADSPEED}</em> {postrow.USER_SPEED_UP}</p><!-- ENDIF -->
#
#-----[  ]------------------------------------------
#

/viewtopic.php

#
#-----[  ]------------------------------------------
# 
'EDITED_MESSAGE'     => $l_edited_by,
#
#-----[   ]------------------------------------------
# 
'USER_SPEED_UP'   => (get_speed_cache($postrow[$i]['user_speed_up']) == $lang['NOT_DEFINED']) ? false : get_speed_cache($postrow[$i]['user_speed_up']),
'USER_SPEED_DOWN' => (get_speed_cache($postrow[$i]['user_speed_down']) == $lang['NOT_DEFINED']) ? false : get_speed_cache($postrow[$i]['user_speed_down']),
#
#-----[  ]------------------------------------------
# 
// 2. All others posts
$sql = "
    [PHP]SELECT
      u.username, u.user_id, u.user_posts, u.user_from,
      u.user_regdate, u.user_rank, u.user_sig,
      u.user_avatar, u.user_avatar_type,
      u.user_opt,
#
#-----[    ]------------------------------------------
# 
u.user_opt,
#
#-----[    ]------------------------------------------
# 
u.user_speed_up, u.user_speed_down,
#
#-----[      398 ]------------------------------------------
# 
$sql = "
    [PHP]SELECT
      u.username, u.user_id, u.user_posts, u.user_from,
      u.user_regdate, u.user_rank, u.user_sig,
      u.user_avatar, u.user_avatar_type,
      u.user_opt,
#
#-----[    ]------------------------------------------
# 
u.user_opt,
#
#-----[    ]------------------------------------------
# 
u.user_speed_up, u.user_speed_down,
#
#-----[  ]------------------------------------------
#

includes/ucp/usercp_register.php

#
#-----[  ]------------------------------------------
#
$tp_data['USER_GENDER'] = build_select('user_gender', array_flip($lang['GENDER_SELECT']), $pr_data['user_gender']);
break;
#
#-----[   ]------------------------------------------
# 
//    .
    case 'user_speed_up':
        $speed = isset($_POST['user_speed_up']) ? (int) $_POST['user_speed_up'] : $pr_data['user_speed_up'];
        if ($submit && $speed != $pr_data['user_speed_up'])
        {
            $pr_data['user_speed_up'] = $speed;
            $db_data['user_speed_up'] = $speed;
        }
        $tp_data['USER_SPEED_UP']    = user_speed_selected('user_speed_up');
        break;
    //    .
    case 'user_speed_down':
        $speed = isset($_POST['user_speed_down']) ? (int) $_POST['user_speed_down'] : $pr_data['user_speed_down'];
        if ($submit && $speed != $pr_data['user_speed_down'])
        {
            $pr_data['user_speed_down'] = $speed;
            $db_data['user_speed_down'] = $speed;
        }
        $tp_data['USER_SPEED_DOWN']    = user_speed_selected('user_speed_down');
        break;
    // END CODE FROM DIMKA3210
#
#-----[  ]------------------------------------------
#
'user_from'        => true,
#
#-----[   ]------------------------------------------
# 
'user_speed_up'    => true,
'user_speed_down'  => true,
#
#-----[  ]------------------------------------------
#

templates/default/usercp_register.tpl 

#
#-----[  ]------------------------------------------
#
<!-- ENDIF -->
<!-- IF $bb_cfg['allow_change']['language'] -->
#
#-----[   ]------------------------------------------
#
<tr> 
    <td>{L_YOUR_SPEED}:</td> 
    <td><img src="images/speed_down.png"> {USER_SPEED_DOWN} / <img src="images/speed_up.png">{USER_SPEED_UP}</td> 
</tr>
#
#-----[  ]------------------------------------------
#

includes/function.php 

#
#-----[  ]------------------------------------------
#
function make_jumpbox ($selected = 0)
#
#-----[   ]------------------------------------------
#
function user_speed($id){
        $sql = "SELECT `speed_id`, `speed_str` FROM `bb_users_speed` WHERE `speed_id` = " . $id;
    $result = DB()->fetch_row($sql);
    return $result['speed_str'];
}    // end user_speed
    function user_speed_selected($mode){
        global $userdata, $lang;
        $v = '<select name="' . $mode . '">';
        $sql = "SELECT * FROM bb_users_speed";
        $result = DB()->sql_query($sql);
        $v .= '<option value="0"> </option>';
            for($i = 0; $i < mysql_num_rows($result); $i++){
                $row = mysql_fetch_row($result);
                $selected = ($userdata[$mode] == $row[0]) ? " selected " : false;
                $v .= "<option value=\"{$row[0]}\"{$selected}>{$row[1]}</option>\n";
            } // end for
        $v .= '</select>';
    return $v;
}    //end user_speed_selected
    function get_speed_cache($mode){
global $lang;
        if(empty($mode))
            return $lang['NOT_DEFINED'];
    if(!CACHE('bb_cache')->get('user_speed')){
        $sql = "SELECT * FROM bb_users_speed";
            $result = DB()->fetch_rowset($sql);
        CACHE('bb_cache')->set('user_speed', $result, 1200);
        } //end if
    $speed = CACHE('bb_cache')->get('user_speed');
    $m1 = $mode-1;
        $return = $speed[$m1]['speed_str'];
        return $return;
}    // end get_speed_cache
#
#-----[  ]------------------------------------------
#

/templates/default/usercp_viewprofile.tpl

#
#-----[  ]------------------------------------------
#
<!-- IF GENDER -->
			<tr>
				<th>{L_GENDER}:</th>
				<td id="user_gender"><b class="editable">{GENDER}</b></td>
			</tr>
			<!-- ENDIF -->
#
#-----[   ]------------------------------------------
#
<!-- IF USER_SPEED_DOWN -->
			<tr> 
                <th class="vBottom">{L_YOUR_SPEED}:</th> 
                <td><img src="images/speed_down.png" title="{L_DOWNLOADSPEED}"> {SPEED_USER_DOWN} / <img src="images/speed_up.png" title="{L_UPLOADSPEED}">{SPEED_USER_UP}</td> 
            </tr>
			<!-- ENDIF -->
#
#-----[  ]------------------------------------------
#

includes/ucp/usercp_viewprofile.php 

#
#-----[  ]------------------------------------------
#
'LOCATION'             => $profiledata['user_from'],
#
#-----[   ]------------------------------------------
# 
'SPEED_USER_UP'   => (get_speed_cache($profiledata['user_speed_up']) == $lang['NOT_DEFINED']) ? false : get_speed_cache($profiledata['user_speed_up']),
	'SPEED_USER_DOWN' => (get_speed_cache($profiledata['user_speed_down']) == $lang['NOT_DEFINED']) ? false : get_speed_cache($profiledata['user_speed_down']),
#
#-----[  ]------------------------------------------
#

language/lang_russian/lang_main.php

#
#-----[  ]------------------------------------------
#
?>
#
#-----[   ]------------------------------------------
# 
//   
$lang['NOT_DEFINED'] = " ";
$lang['UPLOADSPEED'] = " "; 
$lang['DOWNLOADSPEED'] = " "; 
$lang['YOUR_SPEED'] = " ";
#
#-----[  ]------------------------------------------
#

language/lang_english/lang_main.php

#
#-----[  ]------------------------------------------
#
?>
#
#-----[   ]------------------------------------------
# 
//   
$lang['NOT_DEFINED'] = "Not Specified";
$lang['UPLOADSPEED'] = "Upload speed"; 
$lang['DOWNLOADSPEED'] = "Download speed"; 
$lang['YOUR_SPEED'] = "Internet bandwith speed";
#
#-----[  ]------------------------------------------
#

/templates/default/tpl_config.php

#
#-----[  ]------------------------------------------
#
// attach_icons
#
#-----[   ]------------------------------------------
# 
// internet_speed_icons
$images['sd_u']             = $_img .'speed_down.png';
$images['su_u']             = $_img .'speed_up.png';
#
#-----[  ]------------------------------------------
#
'ICQ_IMG'         => ($bb_cfg['text_buttons']) ? $lang['ICQ_TXTB'] : '<img src="'. $images['icon_icq'] .'" alt="'.$lang['ICQ_TXTB'].'" title="'. $lang['ICQ'] .'" />',
#
#-----[   ]------------------------------------------
# 
'TS_DOWNLOADSPEED'          => ($bb_cfg['text_buttons']) ? $lang['DOWNLOADSPEED'] : '<img src="'. $images['sd_u'] .'" alt="'. $lang['DOWNLOADSPEED'] .'" title="'. $lang['DOWNLOADSPEED'] .'" />',
			'TS_UPLOADSPEED'          => ($bb_cfg['text_buttons']) ? $lang['UPLOADSPEED'] : '<img src="'. $images['su_u'] .'" alt="'. $lang['UPLOADSPEED'] .'" title="'. $lang['UPLOADSPEED'] .'" />',
#
#-----[ /   ]------------------------------------------
#
# !